
<html>

<head>
<?php include("../../MerchandiseBay/conn.php"); ?>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>


<?
date_default_timezone_set('Asia/Kuala_Lumpur');
$today = date("m/d/Y");
$sqlReservation="select * from users, reservation where reservationdate >= '".$today."' and reservation.name = users.username group by reservation.id order by reservationdate asc";
$qryReservation=mysql_query($sqlReservation,$conn);

?>

</head>

<body bgcolor="#0099CC">
<table border="0" width="100%" id="table1">
	<tr>
		
    <td><font color="#0000FF"><strong><em>&nbsp;Welcome To Admin Site</em></strong></font></td>
	</tr>
	<tr>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td>
		<table border="1" id="table2">
        <tr> 
          <td colspan="9">&nbsp;<strong><font size="4" face="Times New Roman, Times, serif" color="#000000">
            Reservation List</font></strong></td>
        </tr>
        <tr> 
          <td width="39" bgcolor="#E4E4E4"><font size="1" face="Verdana"> Number</font></td>
		  <td width="107" bgcolor="#E4E4E4"><font size="1" face="Verdana"> Name</font></td>
          <td width="72" bgcolor="#E4E4E4"><font size="1" face="Verdana">Tel no</font></td>
          <td width="114" bgcolor="#E4E4E4"><font size="1" face="Verdana">Email </font></td>
          <td width="106" bgcolor="#E4E4E4"><font size="1" face="Verdana"> Reservation Date </font></td>
          <td width="148" bgcolor="#E4E4E4"><font size="1" face="Verdana"> Rservation Time</font></td>
         </tr>
        <?
		$count=1;
		while($rowReservation=mysql_fetch_assoc($qryReservation)) {?>
        <tr> 
          <td width="39" align="center"><?=$count?></td>
		  <td width="107" valign="top"><font size="1" face="Verdana"> &nbsp;<a href="detailReservation.php?d=<?=$rowReservation['id']?>"> 
            <?=$rowReservation['name']?>
            </a></font></td>
          <td width="72" valign="top"><font size="1" face="Verdana"><?=$rowReservation['telno']?></a></font></td>
          <td width="114" valign="top"><font size="1" face="Verdana">&nbsp; <?=$rowReservation['email']?></a> </font></td>
          <td width="106" valign="top"><font size="1" face="Verdana">&nbsp; <?=$rowReservation['reservationdate']?></a></font></td>
          <td width="148" valign="top"><font size="1" face="Verdana">&nbsp;<?=$rowReservation['reservationTime']?></a> </font></td>
         
         <?
	$count=$count+1;
	?>
		</tr>
        <?}?>
        <tr> 
         
         
        </tr>
      </table>
		</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
	</tr>
	
  <tr> 
    <td>&nbsp;</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
	</tr>
</table>

</body>

</html>